home
***
CD-ROM
|
disk
|
FTP
|
other
***
search
/
Hottest 6
/
Hottest 6 (1996)(PDSoft)[!].iso
/
software
/
business
/
databases
/
bbaseiii
/
bbase.doc
< prev
next >
Wrap
Text File
|
1978-11-24
|
78KB
|
1,749 lines
DOCUMENT bBaseIII V3.01 © 1993, 1994 by Robert Bromley
bBaseIII
Version 3.01
by
Robert Bromley
August 7, 1994
0.0. TABLE OF CONTENTS
1 INTRODUCTION
1.1 What is bBaseIII?
1.2 Feature Summary
1.3 Hardware Requirements
1.4 Software Requirements
1.5 Restrictions
1.6 To Order the Registered Version
1.7 Starting bBaseIII
1.8 The bBaseIII Screen
1.9 The Screen Colors
1.10 The Information Box
1.11 Copyrights
2 THE REQUESTERS
2.1 The ARP File Requester
2.2 The Input Requester
2.3 The Choice Requester
2.4 The Pop-Up Requester
3 THE CURSOR KEYS
3.1 If the Input Requester is NOT Open
3.2 If the Input Requester IS Open
4 THE SCREEN GADGETS
5 THE PROGRESS BAR
6 THE NOTES OPTION
7 DESCRIPTION OF MENU ITEMS
7.1 Project Menu
7.1.1 Create a New Database <F1>
7.1.2 Open an Existing Database <F2>
7.1.3 Show All Records <A>
7.1.4 Show Tagged Records
7.1.5 Save Database <F3>
7.1.6 Save As
7.1.7 Save Tagged Records
7.1.8 Merge a Database
7.1.9 Show Available Memory
7.1.10 Encrypt/Decrypt a File
7.1.11 Help <Help>
7.1.12 About
7.1.13 Quit <Esc>
7.2 Sort Menu
7.2.1 Incremental Sort <F4>
7.2.2 Decremental Sort <F5>
7.3 Search Menu
7.3.1 Search Fields <F6>
7.3.2 Search Notes
7.3.3 Tag All
7.3.4 UnTag All <U>
7.3.5 Tag Invert
7.3.6 Next Tagged Record <X>
7.3.7 Goto a Record <G>
7.4 Edit Menu
7.4.1 Field Titles
7.4.2 Swap Position of 2 Fields
7.4.3 No. of Rows in Notes Area
7.4.4 Fast Forward/Reverse
7.4.5 Text Reader
7.5 Print Menu
7.5.1 Displayed Record <F8>
7.5.2 Select Print Options <F9>
7.5.2.1 Hardcopy Reports
7.5.2.2 Mailing Labels
7.5.3 Top Margin
7.5.4 Form-feeds
7.5.5 Create WordPerfect Mail-Merge Data File
7.5.6 Create Final Copy Mail-Merge Data File
7.5.7 Create Final Writer Mail-Merge Data File
7.5.8 Create ProWrite Mail-Merge Data File
7.6 Add Menu
7.6.1 A Field
7.6.2 A Record <F10>
7.6.3 Add Record At
7.6.4 Displayed Record <C>
7.7 Delete Menu
7.7.1 A Field
7.7.2 Displayed Record <Del>
7.7.3 All Tagged Records <D>
7.7.4 UNdelete a Record
7.8 Notes Menu
7.8.1 Enable
7.8.2 Disable
7.8.3 Edit <N>
8 OTHER FEATURES
8.1 The "Disable Save" Option
8.2 The Low Memory Warning
8.3 The Tag List
8.4 Cut and Paste Operations
9 SUMMARY OF KEYBOARD COMMANDS
9.1 With the Main Window Open
9.2 With the Input Requester Open
9.3 With the Print Options Window Open
10 THE CONFIGURATION FILE
11 EXAMPLE DATABASES
12 THE COMPETITION
13 A NOTE ON ERROR MESSAGES
14 IF YOU HAVE A PROBLEM!
1. INTRODUCTION
1.1. What is bBaseIII?
bBaseIII is a full-featured, graphically interfaced, reasonably fast
and, I think you will agree, quite an easy-to-use database program.
Basically, it will sort, search for, display and print out stored
information, but wait, there's more!
Refer to Section 1.2 - `Feature Summary'.
Once a database has been loaded from disk, all modifications are done in
computer memory, and will NOT be permanently saved until the database is
saved to disk. This can be done using the menus, the function keys,
or upon quiting.
Almost all functions of bBase may be accessed from the menus, and most
also have keyboard equivalents. These are all described in Section 9 -
` SUMMARY OF KEYBOARD COMMANDS'.
It multi-tasks extremely well, as it does not burn up CPU time while not
actually performing operations.
bBaseIII was written in HiSoft BASIC Version 1.05, and compiled using
the HiSoft BASIC Professional © compiler.
1.2. Feature Summary
Some of the features of bBaseIII are:
* Very straightforward and EASY to use. (One user described it as
having a "zero learning curve").
* Complete Graphical User Interface.
* Notes may be optionally attached to each record, independent of the
sorting fields, which will store over 600 bytes of data.
* 16 fields, plus 8 rows of Notes.
* Incremental or decremental sort, on any field.
* Uses a fast shell-sort algorithm.
* Add or delete a field at any time.
* Restore deleted records.
* Save any or all records to an ASCII database file, that may be edited
and/or imported into another program.
* Save records in a format which can be (mail) merged into form
letters created by popular word processors.
* Merge bBaseIII databases.
* Optionally display entire database, or a filtered list, a screenful
at a time.
* Print out a record, a filtered list, or the whole database,
in many different formats.
* Print mailing labels.
* Reference to the documentation can be made from within the program,
in hypertext mode if you use AmigaGuide or MultiView, or otherwise in
ASCII style. The appropriate file will be loaded automatically.
* Databases may be scrambled for security, and then restored.
* Search in any/all field(s), or the "Notes" Area (if active).
* Range Search, (less than or greater than) in any (or all) field(s).
* Any record may be quickly accessed with just a few mouse-clicks.
* If you don't like the default colors, you can specify your own.
* Optionally disable the "Save to Disk" option to prevent accidental
alteration of the database.
* Well behaved in a multi-tasking environment.
* See the Revision History file for a more complete list.
1.3. Hardware Requirements
Database programs can tend to gobble up large amounts of memory.
bBaseIII is no exception. Since bBaseIII opens on it's own screen,
and reserves memory to hold the entire database, it requires about
1 Meg. of available memory to run. bBaseIII_600 and the Demo version
require about 550K.
Therefore, bBaseIII will not run on a basic 512K machine.
I have personally tested bBase on unaccelerated A500 and A2000
computers using WB1.2, WB1.3 and WB2.04, and an '030 A3000 running
WB2.05 (does it ever fly on that machine!). Other users have told me
that it also works "great" with a 40 mhz 68030 processor, some 32-bit
SRAM, and an A4000 with WB3.0, so I think it will work on any Amiga.
1.4. Software Requirements
The arp.library MUST be present in your LIBS: directory for bBaseIII
to run. This library is included with this package. Clicking on the
Install_Lib icon will execute a script that will check which version of
the library you already have, if any, and ask if you want the included
one installed.
Some other standard AmigaDOS libraries, as well as Fonts:topaz.font
(specifically, topaz 11), are also required.
1.5. Restrictions
bBaseIII: A database of approximately 640K without the Notes option,
(500K with Notes), or 1250 records, whichever comes first.
bBaseIII_600: A database of approximately 290K without Notes,
(220K with Notes), or 600 records, whichever comes first.
Both:
Maximum Number of Fields: 16
Maximum Number of Rows in the Notes area: 8
Maximum Field Length: 50 characters (76 characters in the Notes area)
Maximum Record Size: 800 characters (1408 characters with Notes enabled)
Maximum Length of Field Titles: 18 characters
Maximum Length of Database Name: 22 characters
1.6. To Order the Registered Version
bBaseIII is a shareware program. Having tried the Demo version, if you
would like to obtain a copy of the Registered version, with the full
1250 record capability, just send your shareware registration fee to the
address shown in Section 14 - ` IF YOU HAVE A PROBLEM!'.
The requested registration fee for this version is a minimum of $18 U.S.,
or the equivalent in your currency, except:
1. Previously registered users of bBaseIII can obtain this upgraded
version for:
$10 U.S., if upgrading from version 1, or
$ 5 U.S., if upgrading from version 2.
2. If shiping to Canadian addresses, Canadian dollars will suffice.
1.7. Starting bBaseIII
From the CLI; usage is: Run bBaseIII [-m -n -p -s -fFilename]
If the -m switch is used, the memory check usually made when a data
file is loaded will be suppressed. This may also be accomplished from
` THE CONFIGURATION FILE'.
(Refer to Section 7.1.9 - `Show Available Memory <M>').
The -n switch is provided primarily for use with the palette adjuster.
(Refer to Section 1.9 - `The Screen Colors'). If you are not trying to
determine custom colors for ` THE CONFIGURATION FILE', you probably
needn't use it.
Including the -p switch will make the bBase screen and window PAL sized,
ie. 640 x 512 pixels, however, only 400 pixels of height is utilized.
Some PAL users seem to want this - I'm not sure why.
Including the -s switch will start bBase with Saves disabled.
NOTE:
These four features can be utilized by using the configuration file
as well as the command line. This may be particularly helpful to
users who start bBase from the Workbench, but still want to utilize
these switches. If there is any conflict, the command line values
will take precedence.
Including the -f switch will automatically load the requested database
file. If using this switch, it must be the last switch on the command
line. Do not leave a space between "-f" and the filename, and do not
include the ".bbase" extension. EG.:
Run bBaseIII -s -fDF0:Files/Recipes
will automatically load the file "DF0:Files/Recipes", and the Save
function will be disabled.
From the Workbench; just click on the bBaseIII icon.
When bBase is initially run, all of the menu items, except six items
in the Project menu, will be ghosted until a database file is loaded.
1.8. The bBaseIII Screen
The bBaseIII screen is a full (NTSC) size, high resolution, borderless,
interlaced screen using 8 colors. For PAL users, the screen can be made
taller by using the -p switch, or by specifying a larger value in
` THE CONFIGURATION FILE'. It will autoload the Topaz 11 font if it is
not already being used. This keeps the data in its proper place on the
screen, and also makes it easier to read.
bBase does not have a back or front gadget. This means that some WB1.3
users may be unable to access any other screens, with the exception of
using <Left Amiga - N> to return to the Workbench screen.
A "screen shuffler" program, of course, will solve this problem.
To anyone who still does not have one of these programs, I highly
recommend that you get one - they generally make life easier. There are
a variety of shufflers available in Fred Fish's collection: AutoCLI,
Mach (II, III, IV) and MouseAide to name just three, or if space is at a
premium, try QMouse. There are two flavors of QMouse, one for WB1 and
another for WB2. Both of these tiny little wonders do a lot in under 4K.
As an aid to those who may have this problem, QMice will be included on
the Registered disk.
On computers running AmigaDOS Release 2, the default <Left Amiga - M>
combination of the IControl commodity seems to do the job well.
If getting to other screens is a real problem for you, as a last resort
you can start bBase with the -n switch. (Refer to Section 1.7 -
`Starting bBaseIII'). This will give you a small piece of the titlebar
to grab, so you may drag the bBase screen down, exposing the other
screens behind.
1.9. The Screen Colors
Most people seem to find the default screen colors acceptable, perhaps
even pleasing. Some users have indicated, however, that these colors do
not have enough contrast on their monitors (or TVs). I solved that
problem in V2 with a built-in palette requester. However, this requester
is not compatible with the libraries utilized in V3.
Custom colors are still available, but using a different, and, I think,
better, approach. Better, because your custom colors will be loaded
automatically each time bBase is run, rather than having to select them.
When bBaseIII is run, it looks in the S: directory for "bBase.prefs".
Refer to Section 10 - ` THE CONFIGURATION FILE'. If found, it will use
the colors contained therein, otherwise, it will use the defaults. So
how do I get my colors into this file, you ask? Well, it is fairly
straight-forward, actually. First, you need to know the red, green and
blue (RGB) values of the colors you want. The easiest way to get these,
is to put a palette adjuster on the bBaseIII screen.
There is a palette adjuster included in the Utilities drawer of the
Registered package, which is far superior to the one that Commodore
provides. Among its many features, XColor V1.2 has the ability to jump
from one screen to another. So, to get your RGB values:
1. Run XColor. It will appear on the Workbench screen.
2. From a shell window, run bBaseIII using the -n switch. (Refer to
Section 1.7 - `Starting bBaseIII'). This is a special mode that makes
the bBase window a bit narrower, so that a piece of the screen titlebar
is visible at the top-left corner. Click on this piece, and holding the
LMB down, drag the bBase screen down, exposing the XColor window.
3. Click on the "SCREEN" gadget. The XColor adjuster should now appear
on the bBase screen. Drag the bBase screen back to the top of the
monitor.
4. You will see the 8 bBase colors at the top, and 3 sliders labeled
R, G and B. To the right of each slider is the value of its R, G and B
component. This number is in Hex, ie. it will be either a number from 0
to 9, or a letter from A to F. If you click on the second color patch,
which is cyan, you will see that the R slider is full to the left,
showing a value of 0, while the G and B sliders are full to the right,
showing a value of F.
5. This is a very versatile palette adjuster - read the enclosed
documentation to understand all of its abilities. Play with the sliders
until you get the colors just the way you want them (good luck!). When
they are correct, click on the first color patch (upper left), and write
down the RGB values for that color, separated by commas. As an example,
the values for cyan would be: 0,F,F. On separate lines, write down the
RGB values for the remaining 7 colors.
6. The Hex letters will now have to be changed to numbers, but this is
easily done. Simply substitute 10 for any As, 11 for B, 12 for the Cs,
13 for D, 14 for E, and 15 for any Fs. Easy, eh? When you are finished,
click on the XColor close gadget, and quit bBaseIII. These values must
now be entered into the "S:bBase.prefs" file, replacing the existing
values, using a text editor.
If I could simplify this procedure, I would. But as of now, the only
alternative is to have no palatte changing capability at all. At least
this only has to be done once, then your colors are always available.
There are two example configuration files included. The first,
"bBase_default.prefs", contains values identical to the defaults. If you
copy this to S: and name it bBase.prefs, it will be used, but you would
not notice any difference. If you are planning to use a configuration
file, I would recommend that you use this one, and make any required
changes to it.
The other example, "bBase_demo.prefs", has a different color palette, and
the -n switch is also activated for demonstration purposes. If this one
is copied as "S:bBase.prefs" before bBaseIII is run, it will demonstrate
how ` THE CONFIGURATION FILE' can be used to get different colors. So,
to get the colors YOU want, simply replace the color values in
"bBase_default.prefs" with the values you determined by using XColor,
copy it to S: and rename it "bBase.prefs", then run bBaseIII. It will
find the file, and use the color values in it.
If the "S:bBase.prefs" file is present, but is not in the correct format,
you will be notified, and the default vaules will be used.
1.10. The Information Box
This is the single line box at the bottom of the Main window. Messages
and requesters will appear here to give and receive information that is
required by the user and the program.
1.11. Copyrights
bBaseIII is © 1993, 1994 by Robert Bromley. All rights reserved.
This program, and its documentation, is provided "as is", without
warranty of any kind, expressed or implied, including, but not limited
to the implied warranties of merchantability and fitness for a particular
purpose. Use this program at your own risk and discretion.
bBaseIII is shareware, and not Public Domain. The Demo version ONLY
may be distributed, providing that this file is included, unaltered,
with ALL distribution copies.
The Demo version is identical to the Registered version in all respects,
except that it will not load databases of larger than about 220K, or
save databases of larger than 30 records. This is enough to give you the
"flavor" of the program.
Needless to say, it is illegal to alter the bBaseIII programs in any way.
AmigaGuide is © 1991-3 by Commodore-Amiga, Inc.
ARP V39.1 is © 1987, 88, 89 by ARP Authors.
HiSoft BASIC Professional V1.05 is © 1988 by HiSoft and MichTron, Inc.
MuchMore is © 1991 by Fridtjof Seibert.
QMouse V1.6 is © 1989 by Lyman Epp.
QMouse V2.02 is a Public Domain program authored by Dan Babcock.
XColor V1.2 is a Public Domain program authored by Roger Fischlin.
All trademarks are the property of their respective holders.
2. THE REQUESTERS
2.1. The ARP File Requester
The requester used when asking for a file to load or save is the
standard ARP file requester.
2.2. The Input Requester
This requester is used for general data input. It has full editing
capabilities. Pressing <Ctrl - Q> will move the cursor to the Start of
the text, <Ctrl - W> will jump the cursor to the beginning of the next
Word, and <Ctrl - E> will move the cursor to the End of the text.
It may be blanked at any time by pressing the <Tab> key.
Any time this requester is open, pressing <Esc> will close it. In this
case, the data line will revert to what it was before the requester was
opened, ie. the changes will be lost. To accept the changes, use either
<F10>, or the <Return> key.
2.3. The Choice Requester
This is the "Are you sure?" type requester. It appears at the upper-left
corner to provide information, or advise you of some impending action.
Typically, it will give you the option to Proceed, or Cancel that action.
2.4. The Pop-Up Requester
If bBase requires information from the user that cannot be answered by
just a Yes or No, this requester will appear, sometimes at mid-screen,
and sometimes in `The Information Box'. This is the same as the
Input Requester, except that the allowable input is sometimes restricted.
EG, if you want to delete a field, you will be asked which one. If the
database only has 7 fields, an answer of 8 will not be accepted.
3. THE CURSOR KEYS
3.1. If Input Requester is NOT Open
Pressing the Cursor Up key will take you directly to the First Record.
The Cursor Down key displays the Last Record.
The Cursor Left key shows the Previous numerical Record, and
the Cursor Right key will show the Next numerical Record.
You can also move through the records using the mouse.
Please note that for "browsing" through the database, the Left/Right
cursor keys are the slowest way to do it. If you are looking for a
particular record, I would encourage users to either search for it,
or use the Alphabetic Jump Bar. This will be much faster.
(Refer to Section 4 - ` THE SCREEN GADGETS').
3.2. If the Input Requester IS Open
Whenever you are in Edit mode (when the input requester is open, so that
you may enter or change data), Cursor Left/Right moves the cursor
within the gadget, while Cursor Up/Down moves through the fields.
You may also position the cursor by clicking in the requester, or by
using the Ctrl keys. (Refer to Section 2.2 - `The Input Requester').
4. THE SCREEN GADGETS
At the top left corner of the screen, there is a gadget labeled "Esc".
Clicking on this gadget is the same as pressing the <Esc> key. The
action performed when this gadget is clicked depends on your present
situation, and is explained in the relevant sections, but generally
it will cancel an action, or close a window. If no extra windows are
open, it will initiate the Quit sequence.
Clicking in the program title box is equivalent to selecting "About"
in the Project menu.
Just above the upper-right corner of the Data area is the Tag box.
Any records which are currently on `The Tag List' will be identified by a
check-mark in this box. Clicking in this gadget will act as a toggle.
If the currently displayed record is not on the Tag List, ie. not
"tagged", then clicking here will add it to the list. If the displayed
record is tagged, then clicking here will remove it from the list.
Pressing <T> is the keyboard equivalent for this feature. (Refer to
Section 7.3.3 - `Tag All'), and Section 7.3.4 - `UnTag All <U>').
The number of records currently on the Tag List, if any, will be
displayed just to the left of the Tag box.
Clicking in the "Current Database:" box (or pressing the <F1> key) is
equivalent to selecting "Open an Existing Database" in the Project menu.
Between the "Current Database:" box and the "Record Number:" box are four
small, white arrow-heads. These gadgets represents the cursor keys, and
you can move about the database using these gadgets and the mouse instead
of the cursor keys, if you so desire, as follows:
Clicking on the Up Arrow will take you directly to the First Record.
Clicking on the Down Arrow will take you to the Last Record.
The Left Arrow will show the Previous numerical Record, and
the Right Arrow will show the Next numerical Record.
Just outside of the horizontal arrow gadgets are invisible Fast Forward
(or Reverse) gadgets. Clicking in these areas will send you forward
(or backward) through the database 10 records at a time. This number is
user configurable. (Refer to Section 7.4.4 - `Fast Forward|Reverse').
The keyboard equivalent of these "fast" gadgets are the "<" and ">" keys.
Clicking on the "Record Number:" box (or pressing <G> on the keyboard)
will bring up the pop-up requester, asking for the number of a record
to "Go to". After entering a legal number, the requested record will
be displayed. Press <Esc> to cancel.
Clicking in the Title Area is equivalent to selecting "Field Titles" in
the Edit menu.
Clicking in the Data Area (or presing <Return>) will put you in Data Edit
mode.
Clicking in the Note Area (or pressing <N> or the <Space Bar>) will put
you in Note Edit mode.
There is an "Alphabetic Jump Bar" located just below the Notes Area,
consisting of the letters a to z. Clicking on one of these letters will
open a window showing all of the records that begin with the selected
letter, in the field that the database is sorted on. EG, if your first
two fields are First Name and Last Name, and the database is sorted on
the second field, then clicking on "h" will show all records of persons
whose LAST name begins with "H". If no last name begins with "H", you
will be informed. The keyboard equivalents to clicking on these letters
are the <Shift - Letter> keys - eg, <Shift - H> would do the same as
described above. The database must be sorted after adding records for
this feature to always work correctly.
I have reluctantly extended this feature to include the fields which are
sorted numerically. Pressing one of the UNshifted number keys, from 1
to 0, will show you all records begining with that number, IF the
database was sorted on a field containing numbers. Otherwise, you will
be informed that there are no records begining with the selected number
in the sort field. The problem with this is that if you are aligning
your numeric entries, (Refer Section 7.3.1 - `Search Fields <F6>', for
a discussion on aligning numeric entries), you will not be able to use
this feature to go to these records. At any rate, this restriction only
applies to databases which are sorted on fields with numeric data that
must be aligned for sorting or searching purposes, which I suspect will
not be too many.
To help you remember which field the database is sorted on, after a sort
has been done, an "s" will be displayed between the Title and Data
areas next to the sorted field.
5. The PROGRESS BAR
When time consuming actions are being performed, eg. loading, searching,
saving, sorting, etc., a Progress Bar will appear, in place of the
Jump Bar, to assure you that "something is happening", and visually
display to you just how the job is progressing. The length of the bar
represents the number of records involved in whatever operation you are
performing.
6. THE NOTES OPTION
bBase may be run with, or without the Notes option active. When a
database is first created, you will be asked if you want to activate
this option. When a database is loaded, bBase will determine if this
option should be activated, and react accordingly.
Without the Notes option, the record storage is limited to 16 fields,
for a total capacity of 800 characters. This will result in faster
searches, sorts, saves, etc., as there is less information to process.
With the Notes option, each record has available an additional Notes area
of up to 608 characters, which can be searched, but not sorted.
This increases each record's capacity, but slows down program processing
somewhat. Also, the database will not be able to hold as much data, as
some of the alloted memory is reserved for a full Notes area, whether it
is used or not. (Refer to Section 1.5 - `Restrictions'). The choice is
yours.
The Notes option may be activated or de-activated, and the number of
Note rows set, at any time from within the program.
(Refer to Section 7.4.3 - `No. of Rows in Notes Area', Section 7.8.1 -
`Enable', and Section 7.8.2 - `Disable').
As your databases become progressively larger, operations naturally
become progressively slower. If you find that operations are TOO slow,
then, if feasable, set aside some data fields as comment fields, and
disable the Notes option. This will speed things up enormously.
7. DESCRIPTION OF MENU ITEMS
The most logical way to describe the operation of bBaseIII is probably
by describing the menu operations. The keyboard equivalents, where
applicable, are shown along with the menu titles.
7.1. Project Menu
7.1.1. Create a New Database <F1>
(If you are working on an existing database, and it has been altered,
you will be asked if you want to save it before creating a new one).
This will bring up the ARP file requester, asking for a name for your
new database. Any filename of 22 characters or less will do.
A requester will then ask if you want to activate the Notes option. If
you respond <Y>es, you will be asked how many rows the Notes area will
have. The maximum is 8 rows of 76 characters each, for a total capacity
of 608 bytes. The number of Notes area rows may be altered anytime.
(Refer to Section 7.4.3 - `No. of Rows in Notes Area').
Next you are asked how many fields the new database will require.
There may be up to 16 fields in each database. Fields may be added or
deleted at any time.
You are then asked for the TITLES of each field of the database.
Each field title may be a maximum of 18 characters long, and may be
changed at will. (Refer to Section 7.4.1 - `Field Titles').
A "(1)" will appear, along with the input requester. Enter the title of
your first field, eg. Last Name, First Name, Company, Address, or
anything else. When it is correct, hit <Return>, and a "(2)" will appear
on the next line with the requester. Enter the title of the second, and
all other fields, in this manner.
The screen will now show all the field titles, `The Information Box', the
filename as first entered, a blank Data area, and the record number,
which at this point will be "1". The total number of records is
continuously displayed beside the record number. It will now also
show "of 1".
The input requester will now appear in the first field of the first
record, ready for you to enter data. Enter the data.
NOTE:
Double quotes are not accepted in any data field, as that would mess
up the alignment of all the following fields. Single quotes are OK.
A data entry may be a maximum of 50 characters long. When it is correct,
hit <Return>, and the requester will move to the second field. When all
fields are complete, (or you press <F10>), the requester will close.
To add more records, select "Add - A Record" from the menu, or press
<F10> again. Complete all records in this manner. In this version,
there is a limitation of 1250 records.
7.1.2. Open an Existing Database <F2>
If you have previously created a database, and the ".bbase" file for that
database is stored on a disk, then use this item to access it. If you are
working on an existing database, and it has been altered, you will be
asked if you want to save it before loading another.
Select the database file in the requester, and that database will be
retrieved and shown on screen. At this time, the available memory
and the relative database size will be briefly displayed, unless this
operation was suppressed in ` THE CONFIGURATION FILE', or with the
"-m" switch. Refer to Section 3 - ` THE CURSOR KEYS', and Section 4 -
` THE SCREEN GADGETS', for instructions on moving about the database.
While a record is displayed, `The Information Box' will instruct you to
press "<Return> to Change Data". Do so, and the requester will appear
in the first field, with that field's data. <Return> or <Cursor Up/
Cursor Down> to the field you want to change, and make the changes.
At this point, you may either <Return> through all fields, or press <F10>
to exit Edit mode. The altered record is now displayed.
NOTE:
ANY time you are in Edit mode, whether entering, changing or
searching for data, pressing <F10> will exit Edit mode, and use
the data shown when you exited. Pressing <Esc> will also exit Edit
mode, but any changes made to the last line will be lost.
7.1.3. Show All Records <A>
If you want to quickly glance at more than one record at a time, this
will open a full-sized window, and display the first 60 or so characters
of ALL records, one record to a line. Use the scroll bar to see all of
the records, and click on "Cancel" to leave this function. If you see a
record you want to examine in detail, just click on it. You will then
exit the Display window, and return to the Main Screen, with the
requested record displayed.
7.1.4. Show Tagged Records
This works the same as `Show All Records <A>', except that ONLY the
tagged (Refer to Section 7.3.1 - `Search Fields <F6>') records are
displayed.
7.1.5. Save Database <F3>
If the database has been altered since last saved, it will be saved to
disk under the current filename, after confirmation. The file will have
the extension ".bbase" automatically appended.
If it has NOT been altered, you will be so informed, and given the
oportunity to abort the save.
NOTE:
Saving a large database may be a slow process on an unaccelerated
computer. If you find that this is the case, I suggest you save it to
RAM: first, then use the AmigaDOS or Workbench "Copy" function to copy
it to disk.
7.1.6. Save As
You will be prompted for a name to save the database. It is not
necessary include the ".bbase" extension at this time - it will be
appended automatically.
7.1.7. Save Tagged Records
The tagged records may be saved as a separate .bbase file. It may be
useful to use just some records as the seed of a new database. This is
also how records are copied from one database to another - save them
using this function, then merge the resulting database to another one.
7.1.8. Merge a Database
Two similar databases can be merged together. In order for this to work,
both databases must have the same number of fields in both the Data and
Notes areas. If the field titles are different, you will be informed,
however the merge may continue.
WARNING:
If you try to merge a database that is too large to fit into available
memory, the program will abort with an error. The database size can
be checked with the AmigaDOS "List" command, and available memory can
be checked by pressing the <M> key, (Refer to Section 7.1.9 -
`Show Available Memory <M>'). If there is any chance that the
database will not fit into memory, save the database before merging.
IF the program aborts, any changes made since the last save will be
lost.
7.1.9. Show Available Memory <M>
This repeats the action which can be performed when a database is loaded.
The remaining memory available to bBaseIII is checked. If it is low,
you will be advised. (Refer to Section 8.2 - `The Low Memory Warning').
The number of available bytes remaining are then shown, along with the
approximate relative size of your database. This is shown as a
percentage of the maximum size, taking into account both the number of
available records remaining, and the number of available bytes remaining.
7.1.10. Encrypt|Decrypt a File
For people who have databases with "sensitive" data, (or for people who
are just plain secretive), bBase offers the capability of "scrambling"
a database - or any other file, for that matter.
The file requester will appear. Select the file to be scrambled.
You are then asked for a password. After confirmation, the file will
then be read in, scrambled, and written back to disk under the same name.
Examination of the file will now show that the file characters have all
been changed, many of them are now gibberish.
To restore the file, you need only select this menu item again.
Select the same file, and enter the same password. The file will then be
read in, and written back to disk in its original form. For what it is
worth, executable programs, as well as data files, may be scrambled and
restored - try it with a copy of bBase!
It should go without saying that it is essential that the same password
be entered to unscramble the file as was used to scramble it. If the
wrong password is entered, the scrambled file will be re-scrambled.
The only way to get it back now is to select this item again, and enter
the last password. This will restore the file to the first scrambled
state. Now, if you can still remember the first password, run this file
through once more using it to restore the file to its original state.
Please note that this is a time-consuming operation on large files,
and it does not utilize the Progress Bar.
7.1.11. Help <Help>
This is used for reference to the documentation from within the program.
Both the location of your preferred text reader and the location of the
documentation files may be read from ` THE CONFIGURATION FILE'. If they
are not, you will be prompted for the reader's location, and the doc
files must be in the current directory. If all is well, the text reader
will be run with the file loaded for viewing. If either the text reader
or the documentation are not where they should be, you will be informed.
If you select AmigaGuide or MultiView as your text reader, the file
"bBase.guide" will automatically be loaded. If you select another text
reader, the ASCII file "bBase.doc" will be loaded. Both of these files
are included.
For hypertext users, there is also an index file provided. If used,
bBase.index should be in the same directory as bBase.guide. Clicking on
the "Index" gadget will take you to the index, which is an alphabetical
list of relevent keywords. Clicking on one of those keywords will bring
up the appropriate section of the bBase.guide document.
I you do not use a hypertext reader, I highly recommend MuchMore © as the
reader of choice. MuchMore should also be included with this package.
NOTE:
When MuchMore runs, it opens on top of the bBaseIII screen, as you
would expect. However, when AmigaGuide runs, it opens on the
Workbench screen, behind the bBaseIII screen. Therefore, although it
may appear as though nothing has happened when this is selected, if
push the bBaseIII screen to the back (default <Left Amiga - M>), you
should see the bBase.guide help screen. (Also, when you Quit the text
reader, you could end up back on the Workbench screen, and have to
<Left Amiga - M> to get back to bBase). Refer to Section 1.8 -
`The bBaseIII Screen', for information on screen shufflers. I hope
that by the next release, I will know enough about public screens to
be able to avoid this situation.
The entire AmigaGuide package must be distributed intact, and is too
large to fit on a disk with the bBaseIII package. It is therefore not
included, but can be obtained on Fred Fish Disk 920, and other places.
7.1.12. About
The usual stuff, including the version number.
7.1.13. Quit <Esc>
If the database has been altered, you will be asked if you want to save
it before quiting. The <Q> key can also be used for this function.
7.2. Sort Menu
You may sort the records in the database based on the data in any field.
The sort algorithm is designed to be most efficient when sorting a
database which is already mostly sorted, as will be the case with
databases over 90% of the time. Initial sorts will take a little bit
longer. Naturally, the larger the database, the longer it takes.
After the database has been sorted, an "s" will be displayed between the
Title and Data areas, so that you will always know at a glance which
field the database has been sorted on. If the database was sorted
INcrementally, the "s" will be in the dark background color, and if it
was sorted DEcrementally, the "s" will be a cyan color.
NOTE:
Any time that the database is sorted, `The Tag List' will be lost,
(ie. all records become "UnTagged"), since sorting the database
scrambles the list, and renders it meaningless.
7.2.1. Incremental Sort <F4>
The requester will ask which field you want to sort on. The records will
be incrementally sorted on that field, and record number 1 of the new
list will be shown.
7.2.2. Decremental Sort <F5>
Same as `Incremental Sort <F4>', except records are sorted and displayed
from Z-A, or 9-0.
7.3. Search Menu
7.3.1. Search Fields <F6>
The input requester will appear in the first field of a blank record.
<Return> or <Cursor Up/Down> to the field that contains the data you
want to search for, and enter it. A search string may be entered in more
than one field. When all the criteria has been entered, <Return> through
all the fields, or press <F10>. All records that match ALL the search
criteria become `The Tag List', and the first match is displayed. When a
match is found, you may Print it, Cancel the search, UnTag (or ReTag) the
record, Delete the record, or Review all the records on the Tag List.
(Refer to Section 7.1.4 - `Show Tagged Records'). Pressing <Any Other
Key> will display the next matching record in the list. Searches are NOT
case dependent.
If a match cannot be found, you will be advised "No Matching Records".
Range Search is also available. EG., if you want to search an address
database for all names before Jones, or after Smith, simply add a "<"
or a ">" immediately before the name, with no intervening space.
Or, if you had a field containing birth years, you could find all those
born before (or after), for example, 1965, by entering "<1965".
You could also combine the two, and find all those entries before
(alphabetically) "Jones", and who were born after 1965.
Equal-or-less-than and equal-or-greater-than may also be used by
preceeding the search string with "=<" or "=>" respectively.
Note that the equals sign must come first; "<=" will not work.
Bear in mind that in a search for entries "<p", (which will be treated as
"<P", because search is case independent), bBase will find all entries up
to and including all of the "O" entries, as you would expect. But, if
you search for ">p", the found entries will not start with the Qs, as you
might expect, but will show the Ps as well. This is because, to a
computer, "pa", or "pill", or "pasquale" are all greater than just "p".
So, if you want to search for Qs and above, you should enter ">pzz", or
better still, ">q".
Note also that bBase does not employ the concept of field TYPES, ie,
there are no numeric fields - all fields are of the string type.
Therefore, if you are storing numbers in a field, (eg. 9, 60, & 500),
and you search for all records "<500", bBase will report "No Matching
Records". This is because all strings are compared on a character-by-
character basis. So, when the first character is examined, all other
first characters are compared to "5". All we find is a "9" and a "6",
so bBase deduces that there are no records less than 500.
When entering numeric data that you may wish to search or sort,
therefore, you must ensure that the data is properly aligned. If you
will be entering numeric data with three digits, they must all be
entered with three digits. So, when entering "9", it must be entered as
"009" or " 9", and the "60" entered as "060" or " 60". You will then
find that searches and sorts operate as expected. Searching for entries
of "<70" must now, of course, be entered as "< 70" or "<070".
7.3.2. Search Notes
The requester will appear in the first field of a blank record. Enter
the string you want to search the Notes area for. Once the string has
been entered, the search will begin, and the first record which contains
the entered string in the Notes area will be displayed. You now have the
same options as described above - Print the Record, (the Notes may be
optionally included, if ALL fields of the record are to be printed),
Cancel, Delete, Review the tagged records, or Display the Next tagged
record.
NOTE:
Although the search data is entered in a field, the fields have
nothing to do with this search. It is just a handy place to enter it.
7.3.3. Tag All
All of the records in the database are "Tagged", ie. added to the Tag
List. (Refer to Section 4 - ` THE SCREEN GADGETS').
7.3.4. UnTag All <U>
All records are "UnTagged". `The Tag List' is discarded, and all
references to tagged records in the menus are ghosted. This may be handy
if you want to create a new Tag List by clicking in the Tag Box of some
individual records. Otherwise, the tagged records would be added to the
current Tag List.
7.3.5. Tag Invert
Inverts `The Tag List'. All Tagged records become UnTagged, and all
records that were UnTagged become Tagged.
7.3.6. Next Tagged Record <X>
If you interrupt your "Display the Next Tagged Record" sequence, bBase
will remember where you were in the sequence. Selecting this item will
immediately display the next tagged record after the last one you have
already looked at. As mentioned above, if you should sort the database,
this item will become inoperable.
When the last record on `The Tag List' has been displayed, you will be
advised, "End of Tag List". Selecting this item now, will skip through
the tagged records again, starting at the top of the list.
7.3.7. Goto a Record <G>
Activates the Goto a Record requester - the same as pressing <G>.
(Refer to Section 4 - ` THE SCREEN GADGETS').
7.4. Edit Menu
7.4.1. Field Titles
Use this item to change the titles of your fields. The data itself
is unaffected by this procedure.
7.4.2. Swap Position of 2 Fields
Exchanges the position of two fields and their titles in the database.
EG, move field 3 to where field 7 was, and visa versa.
7.4.3. No. of Rows in Notes Area
The number of rows in the Notes area may be changed at any time.
No loss of data will occur except if the number of rows is reduced.
Then, naturally, data contained in rows greater than the new number of
rows will be lost. In this instance, you will be notified that data
will be lost if you proceed, and how many records will be affected.
You then have the option to Abort, Proceed, or View a list of the
affected records, (which will also abort the procedure).
NOTE:
If the number of rows is reduced, and later increased before
leaving the database, the lost data will be recovered.
Fewer rows result in slightly faster searches, sorts, etc.
7.4.4. Fast Forward|Reverse
The "Fast Forward" arrow gadgets will skip through the database a default
10 records per click, but this is user-configurable. Use this item to
set your own number (maximum 999). This value is not stored in the
configuration file, but is stored with each database. Therefore, you can
have a different value for each database, depending on its size.
7.4.5. Text Reader
Using the ARP File Requester, indicate the location of the text reader
you want to use to read the bBase.guide or bBase.doc file. To have the
proper reader always available, its location should be entered into
` THE CONFIGURATION FILE'.
7.5. Print Menu
With the Print Menu, you can:
- Print a record, some records, or the entire database, either to the
printer, or to an AmigaDOS file.
- Create a data file to Mail-Merge with a word processor.
- Print mailing labels, and more.
7.5.1. Displayed Record <F8>
This item will first ask how many fields are to be printed, and then in
which column position, from 1 to 80, to start printing (in case you want
to print onto a mailing label, or directly onto an envelope). If
` THE CONFIGURATION FILE' was found at start-up, the default column
position will be read from there. Otherwise, the default is 30.
If you elect to print all of the fields, you will then be asked if you
want the Notes printed as well (if this option is active). If you elect
to have the Notes printed, you will then be asked if you also want the
blank lines printed. Some people may want this to make a more
symmetrical report. Otherwise, only those lines containing data will be
printed. (If you want the odd blank line to be included as a "spacer",
then just put 1 blank space on that line, and the space will be printed).
It will then send all characters of the requested number of fields
(and Notes) of the currently displayed record to the PRT: device.
NOTE:
If the alignment of the report is not correct, switch the printer Off,
then back On, just prior to using this item.
7.5.2. Select Print Options <F9>
Opens the Print Options Window from which various formats of hardcopy
reports and mailing labels may be chosen. Select from this window
using the mouse, keyboard, or the Up/Down cursor keys. The keyboard
equivalents are the underlined letters of each label.
At the top, there are toggle gadgets to select "Print All Records" or
"Print Tagged Records"; "Bold On" or "Bold Off"; and "Print to PRT:"
or "Print to File".
Print All Records will do just that. Print Tagged Records will print
all currently tagged records. This toggle is inoperative if there are
no tagged records.
Bold allows you to select either Bold or Normal print styles. Although
you may select Bold On at any time, it is only effective, on my printer
at least, if the Pitch is set to Pica (80 characters per line). Other
printers may not have this restriction.
PRT: or File determines whether the requested records will be printed,
or copied to a file. In the latter case, the file requester will appear,
and you may specify the filename to copy the records to. The default is
"RAM:bBase_report".
At the bottom are gadgets labeled "Print!", "Help" and "Cancel".
"Cancel" is self-explanatory. "Help" opens a Help Window which explains
the terms used in the Print Options Window, so this information is not
included here. "Print!" will print (or copy) the selected records using
the selected format. The <Return> key is another keyboard equivalent
for "Print!".
7.5.2.1. Hardcopy Reports
Database reports can be obtained in these formats:
Adjacent Single Line (Pica, Elite or Condensed).
The "Notes" attached to your records may optionally be also
printed out using this format. Follow the prompts.
Aligned Single Line (Pica, Elite or Condensed).
Block, 2 across
Block, 3 across
Super Space Saver (Block, 5 across)
These are explained in the Help Window, but try them all, and see which
one (or more) best suits your needs.
With each report there will be a title line, containing the name of the
database, and, if your system is showing a current date, the date of the
printing. You will also be given the oportunity of inserting a (maximum)
26 character comment on the title line, between the title and the date.
Just type it in when prompted.
Along the top of the Data area are 4 colored pixels. These pixels will
align with the data entry cursor at the 24, 25, 38 and 43 character
positions. As some of the above reports are truncated to these number of
characters (Refer to the Help Window), they are a guide to indicate that
the data beyond will not be printed when some print options are selected.
7.5.2.2. Mailing Labels
Mailing labels of 15/16 inch, and 1 7/16 inch, in 1-across roll type,
and 2 or 3-across sheet type are all supported.
If you have selected a mailing label option in the Print Options Window,
when you click on "Print!" you will be asked whether your labels are 1,
2 or 3-across, how many fields of your database you want printed on the
label, and in which column you want the printing to start. The column
defaults work for me, but your paper may be aligned a bit differently.
Once this information is received, the printing (or copying) operation
will start.
If you tell bBase you want, for example, 4 fields printed, then the first
4 fields will be printed, in numerical order. Make sure that these are
the ones you want printed. You can temporarily move the fields around,
if desired, to get the alignment you want.
(Refer to Section 7.4.2 - `Swap Position of 2 Fields').
Due to the size constraints of the labels, there are limits on the number
of characters of each field, and the number of fields, that this function
will print. This information is in the Help Window.
7.5.3. Top Margin
The default is to have no specified top margin, but users may specify
one if they wish. You will be told the current setting, and prompted
for a new one. The top margin on printed reports will be equal to
1/8 inch times the number you enter. EG, if you enter "4", then
printed reports will start 1/2 inch down from the top of the page.
If you enter a setting into ` THE CONFIGURATION FILE', that number will
be used as the default.
I expect this may be particularly useful to those using sheet-feed
printers, especially with mailing labels or forms.
7.5.4. Form-feeds
Form-feeds may be generated at any position, or suppressed entirely.
You will be told the current setting (Default, Suppressed, or the setting
you have selected), and be prompted for a new one.
The Default is to generate a form-feed after 62 lines of an Adjacent or
Aligned report (there will also be the Title line on the first page), or
approximately the same for a Block report. (bBase will attempt to keep
the entire block on the same page, so this will vary somewhat). When
printing mailing labels, the default caters to tractor-fed forms, ie,
the print is continuous. If you find this unsatisfactory, you may enter
a different setting into ` THE CONFIGURATION FILE' and that setting will
be used.
Suppressed means that NO form-feeds are generated by bBase. There have
been cases of other programs form-feeding along with bBase, resulting in
a lot of waste paper. Use this if you want another program to do the
form-feeding.
At the prompt, enter "0" to get the Default, "-1" to suppress form-feeds,
or any other number to customize your form-feed setting.
If you have 10 rows of 1 inch sheet-fed mailing label forms, then 60
would be a logical setting. For 7 rows of 1 1/2 inch labels, 63 should
work. Experiment, and use whatever works for your printer.
7.5.5. Create Word Processor Data File
This will save all of the tagged records in a format that will be
accepted by the selected word processor as a secondary, or data file in
a Mail Merge operation. So far, WordPerfect, Final Copy, Final Writer
and ProWrite word processors are supported. You will be asked how many
fields of the records to use, and then the file requester will ask for a
filename to save the data file. The default is "RAM:bBase_merge".
I hope to eventually make this feature compatible with other word
processors, but so far I do not have the information on the format
required by others. If your word processor is not listed, try one
that is - the format just might be the same.
7.6. Add Menu
7.6.1. Add a Field
If you do not already have the full complement of 16 fields, this item
will add a blank field, in a designated location, with a title
consisting of all dots. The title may be modified at any time.
(Refer to Section 7.4.1 - `Field Titles').
7.6.2. Add a Record <F10>
Positions you at an empty record, with the input requester open,
ready for you to enter data into the first field of the new record.
Use the <Esc> key to abort if you arrived here by mistake.
The new record will be at the end of the database.
7.6.3. Add Record At
Same as `Add a Record <F10>', except that you will be prompted for a
record number, the current record number being the default. The new
record will be inserted into the desired spot in the database.
7.6.4. Displayed Record <C>
This item will copy the record which is presently being displayed, and
add it as the last record. bBase will then move to this new, last
record, display it, and open the input requester. It assumes that you
will not want two identical records, and will be wanting to make some
changes to it. If this is not the case, just hit <Esc>. This will be
very handy if you are entering similar records - it will be easier to
make some corrections to an existing record, than enter the whole new
record in from scratch.
7.7. Delete Menu
7.7.1. Delete a Field
You will be asked which field you want to delete. As usual, press <Esc>
to abort. The requested field, and all information contained in that
field in all records will be deleted.
7.7.2. Displayed Record <Del>
After confirmation, the record currently displayed is deleted.
7.7.3. All Tagged Records <D>
After confirmation, all of the tagged records are deleted.
To preview exactly which records will be deleted, refer to
Section 7.1.4 - `Show Tagged Records'.
7.7.4. UNdelete a Record
Any deleted record can be undeleted. A list, similar to "Show All
Records", is presented, showing all of the deleted records. Just click
on the one you want, and it will be restored as the current record
number. If you want it restored to the END of the database, then click
on the blank gadget to the right of the slider before you click on the
record to be restored.
7.8. Notes Menu
7.8.1. Enable
If the Notes option is currently disabled, this will enable notes.
The database structure will be re-writen to allow a default number of
four note rows per record. This number can be changed anytime.
(Refer to Section 7.4.3 - `No. of Rows in Notes Area'). If this feature
is used, the database must be saved, and then re-opened before being
used further, or it will become corrupted. If you elect to proceed,
this action will occur automatically.
7.8.2. Disable
If the Notes option is currently enabled, this will disable notes.
All data in the Notes area will be lost, if the action is not aborted at
the next requester. The database must now be saved, and then re-opened
prior to further use. If you elect to proceed, this action will occur
automatically.
7.8.3. Edit <N> or <Space Bar>
The program is put into Notes mode. Clicking inside the Notes area will
accomplish the same thing. To Edit the Notes, just press <Return>. It
works identically to the Data area of the Main Screen, except that the
keyboard combinations of <Ctrl - N>, <Ctrl - D> and <Ctrl - U> are used
to INsert, Delete or UNdelete a row.
<Ctrl - N> will INsert a blank row at the active row, and all following
rows move down 1 position. <Ctrl - D> will Delete the active row, and
all following rows move up 1 position. <Ctrl - U> will UNdelete, or
restore the previously deleted row to the active row, and all following
rows move down 1 position. In the Insert and UNdelete cases, if there
is data in the last row, you will be advised that it will be lost, and
given the chance to abort. As in the Main Data Screen, the <Tab> key
will blank the row, and no other rows will move.
Pressing <Esc> will exit the Notes Edit mode, and any changes made to the
active row since it became active, will be ignored. Pressing <F10> will
exit the Notes Edit mode with all changes intact.
While in Notes mode, (but not Editing Notes), press <Del> to delete the
entire Note attached to that record. To leave Notes mode, press <Esc>,
<F10>, or the <Space Bar>.
8. OTHER FEATURES
8.1. The 'Disable Save' Option
As a simple security device, mainly as a guard against someone
accidentally altering or erasing data, I have added an option which will
disable the ability to save database changes to disk.
To disable saves, press <Ctrl - S> simultaneously. `The Information Box'
will briefly inform you that saves are disabled, and now any attempt to
save the database to disk will be circumvented. In this case, upon
quiting, a requester will ask if you want to save the database (as
usual). If you select "Save", a second requester will inform you that
the Save option has been disabled. To save the database, at the next
requester, "Do you Really want to Quit?", select "Cancel", re-enable
saves, and quit again.
If you are running bBase from the CLI, using the "-s" switch on the
command line will start bBase with the saves already disabled. If you
are utilizing ` THE CONFIGURATION FILE', entering "1" on the appropriate
line will also do the same.
The <Ctrl - S> combination will toggle between Save Enabled and Save
Disabled. A message will appear briefly in `The Information Box' to keep
you informed of the current status as it changes.
8.2. The Low Memory Warning
When bBaseIII is run, it reserves about 980K of memory to use for
database storage in RAM, arrays, etc. No matter how much RAM your
computer has, this is all that is available to bBase!
When a database is first loaded, bBase will check the available memory
left in the program pool (unless you have taken action to suppress this
check). If the memory available to bBase is less than 5K, this means
that very few more records may be added before the program will generate
an error message.
You will be advised if this low memory situation exists. Press <Any Key>
to cancel the warning. The recommended action is:
1. If you are using bBaseIII_600, start using bBaseIII.
2. If feasable, disable the Notes option.
3. Trim down the size of your database by deleting some old
records, or some of the record notes.
4. If you cannot get all of your information into one database,
some users have split the information over two databases. The
split can be, eg, alphabetical (Names A-M, and Names N-Z);
chronological (Invoices up to 1992, Invoices after 1992); or
catagorical (Classical Tapes, Pop Tapes).
5. Drop me a line. It's possible that a custom version of bBase
that will set aside more memory (if you have it), will solve
the problem. For a $7 fee, I will attempt to create a
"customized" version. Tell me what you need.
6. Perhaps another program would serve you better.
(Refer to Section 12 - ` THE COMPETITION').
The available memory can be checked any time by using the
`Show Available Memory <M>' item in the Project menu.
8.3. The Tag List
The Tag List is usually created by a Search operation. Any matching
records found by a search become the Tag List, and are indicated by a
checkmark in the Tag Box.
Records may be added to (or deleted from) the Tag List by clicking in
the Tag Box. If there are no records currently on the Tag List, clicking
in the Tag Box will create a Tag List of that one record.
8.4. Cut and Paste Operations
Cut, Copy and Paste are fully supported in bBaseIII, (they're just called
something else).
To Cut a record, just delete it.
(Refer to Section 7.7.2 - `Displayed Record <Del>').
To Paste it somewhere else, go to where you want it pasted, and
undelete it. (Refer to Section 7.7.4 - `UNdelete a Record').
To Copy a record within the program, press <C>.
(Refer to Section 7.6.4 - `Displayed Record <C>').
To Copy a record for use with another program, tag it, open the Print
Options Window, (Refer to Section 7.5.2 - `Select Print Options <F9>'),
then "Print Tagged Records" to "a File", in whichever format you prefer.
9. SUMMARY OF KEYBOARD COMMANDS
Generally, pressing the <Esc> key will close a window or requester, if
one is open, abandoning the last change; pressing <F10> will close the
window or requester leaving all changes intact.
9.1. With the Main Window Open
Create a New Database <F1>
Open an Existing Database <F2>
Save the Database <F3>
Incremental Sort <F4>
Decremental Sort <F5>
Search the Fields <F6>
Print the Displayed Record to the Printer <F8>
Open the Print Options Window <F9>
Add a Record <F10>
Show All Records <A>
Copy the Displayed Record <C>
Delete All Tagged Records <D>
Goto a Record <G>
Show Available Memory <M>
Edit the Notes <N> or <Space Bar>
Tag or Untag the Displayed Record <T>
UnTag All Records <U>
Display the Next Tagged Record <X>
Saves Enable/Disable (toggle) <Ctrl - S>
Fast Forward/Reverse through the Records < or > (actually: , or .)
View All Records Beginning with a Letter <Shift - Letter>
View All Records Beginning with a Number <Number>
Delete the Displayed Record <Del>
Quit <Esc> or <Q>
9.2. With the Input Requester Open
Clear the Requester <Tab>
Place Cursor at Start of Text <Ctrl - Q>
Jump Cursor to Start of Next Word <Ctrl - W>
Place Cursor at End of Text <Ctrl - E>
Plus, if you are in Notes Edit Mode
INsert a Row <Ctrl - N>
Delete a Row <Ctrl - D>
UnDelete a Row <Ctrl - U>
9.3. With Print Options Window Open
Print All Records/Tagged Records (toggle) <A>
Bold print On/Off (toggle) <B>
Print to Printer/File (toggle) <T>
Cancel Print and Close Window <C> or <Esc>
Open the Print Options Help Window <H> or <Help>
Start Printing <P> or <Return>
10. THE CONFIGURATION FILE
The configuration file is NOT required - it is provided for more advanced
users who have specific requirements. If it is not found, the program
default values will be used. The example file "bBase_default.prefs"
contains the default values.
When bBase is first run, it looks in the S: directory for the presence
of a file named "bBase.prefs". If it is found, the settings contained
in it will be used. If it is not found, the default settings will be
used. You can tell which settings are being used by checking the 4
colored pixels along the top of the Data area. These pixels will be a
dark color if defaults are being used, or white if the configuration file
settings are used. This file currently contains preferred values for the
following:
* The color palette
* The top margin used for printed reports and mailing labels
* The form-feed position
* The text reader
* The directory containing the documentation file(s)
* The height of the bBase screen and window
* Whether a full-width or narrower window is opened on the bBase screen
* Whether or not to have Saves disabled
* Whether or not to do a memory check when a database is loaded
* The default column to start printing a single record
If you are altering a configuration file, the FORMAT must be precisely
maintained. The commas are especially critical. bBase will check for
an incorrect format, however, and if it does not appear to be correct,
you will be informed, and the default values will be used.
The first line is simply a title.
Lines 2 through 9 contain the color values of the 8 bBase colors. Refer
to Section 1.9 - `The Screen Colors' for information on changing these.
Line 10 specifies the top margin that will be used in printed reports.
The number entered will be the number of 1/8 inches of the margin.
EG, if a "5" is entered here, reports will be printed starting 5/8 inches
from the top of the page. If you enter a number here other than the
default "0", you will also have to change the form-feed setting in order
to get proper reports. (Refer to Section 7.5.3 - `Top Margin').
Line 11 specifies the number of lines to print before a form-feed is
generated. A "-1" means that form-feeds are supressed. A "0" indicates
that the default values will be used. Any other number (1-999) means
that form-feeds will occur after the specified number of lines have been
printed. (Refer to Section 7.5.4 - `Form-feeds').
Line 12 is where you can specify your preferred text reader, which will
be run when the <Help> key is pressed.
Line 13 is where you can specify the directory containing the bBaseIII
documentation. If something is entered here, it must end in either a
colon (:) or a slash (/). EG. DH0:Documentation/
If this is left blank, the doc file must be in the current directory
in order for it to be found.
Line 14 specifies the height of the bBase screen and window. The default
is 400 pixels, however some PAL users may want to enter 512 here.
Line 15 determines the width of the bBase window.
Make it 0 (full width) or 1 (slightly narrower).
Line 16 determines whether or not Saves are disabled.
Make it 0 (Saves enabled) or 1 (Saves disabled).
Line 17 determines whether or not a memory check will be made each time
a database is loaded. Make it 0 (No check) or 1 (Make check).
Line 18 indicates the DEFAULT column at which printing will start when
you are printing a single record (<F8>), but may be changed at the
time of printing.
Lines 19 and 20 are used for error checking.
The rest of the file is only for your information.
11. EXAMPLE DATABASES
There are two example databases included in this package. The file
"Recipes.bbase" is a sample database showing one way of keeping track of
recipes, without having to re-type them all. It merely shows where they
can be found when needed. With this database you can sort the recipes by
Name, Catagory, or anything else. You can search for all recipes
containing a listed ingredient, recipes you have already served to given
people, or just the location of the recipe if you have forgotten which of
your 647 recipe books it is in. I have found this to be very useful.
Address databases have their own unique problem. Most people prefer to
sort this database on the Last Name of the person on record. This
necessitates having separate fields for the Last Name and the First
Names, or using one field with an entries such as "Smith, John", and
"Smith, Mary". Unfortunately, when you want to print this record to a
mailing label or envelope, it does not look too good.
My preferred method of getting around this is shown in the database
"Addresses.bbase". The first field is the sorting field, in the format
of "Smith, John". The sixth field holds the Mailing Name, which can
include a formal salutation, eg. Mrs., Doctor, Captain, etc.
Now, when you want to print this record, just exchange the positions
(Refer to Section 7.4.2 - `Swap Position of 2 Fields') of fields 1 and 6,
and it will print the way you want it. After printing, you can just swap
them back, or quit bBase without saving the change.
This example database also shows another useful method of tagging some
records for a particular purpose. I use a database similar to this
example to store the addresses of friends, family, neighbours and
acquaintances. I was going to open a separate database for my Christmas
card list, but then thought it would be more efficient to use the same
one, since all of the recipients were in that database.
So, somewhere in the record of the Christmas card recipients, I added a
distinctive word - in this case "xmas". Now, come December, I open this
database, search for "xmas", and all of these records become tagged.
I then go to the Print Options Window, select "Print Tagged Records" and
"Mailing Label", then click on "Print", and my card list is printed on
labels. The labels then serve as my hard-copy card list, and as I write
the cards, I stick the label on the envelope rather than having to
address the envelopes by hand.
The example shows the word "xmas" in the first field, but if the Notes
option is being used, it would probably be neater to stick the word
somewhere in the Notes, and use the "Search Notes" menu item to tag the
desired records.
12. THE COMPETITION
I have put literally thousands of hours of work into bBase, and I am
quite proud of the result. For various reasons, though, there are
limitations in the program, (primarily the number of fields and the
number of records), which may make it unsuitable for some purposes.
There are other fine non-comercial database programs available, and I
would encourage you to try them and compare. I have looked at most of
them, and frankly, I prefer bBase, (could I possibly be biased?).
But, some may have features that bBase does not have, which could make
them more suitable for you.
Following is a list of the programs I have noticed. Most of them are
in the Fred Fish collection, and so are readily available.
DataEasy - Fred Fish 526 WBase - Fred Fish 653
DataFiler - Fred Fish 721 VCRFiler - Fred Fish 721
AmigaBase - Fred Fish 792 ProData - Amiga Format Coverdisk Feb 93
Addresser - Fred Fish 767 AMaster - Fred Fish 827
Quickfile - Fred Fish 919
13. A NOTE ON ERROR MESSAGES
Listed below are a some of the error messages that could be
encountered while using bBase, and their probable cause.
* "Insufficient memory". This is pretty self-explanitory - bBase is
requesting more memory than is available. Free memory can be
increased by deleting items from the T: directory, or quitting
other background programs (perhaps a memory cache program?).
* "DEVICE UNAVAILABLE!" Every time I have received this message, it was
due to trying to open a window (Show All Records, Show Tagged Records,
View Notes, or even About), when the system had insufficient Chip RAM
to do so. Closing the windows of other runing programs might help.
* "CAN'T FIND PRINTER DRIVER!". There were five reported cases of this
error occurring in bBaseII. All were from England, and all occcurred
when trying to print a database. The error was caused by independent
companies putting bBase on a self-booting disk that contained a
Release 1.x "devs/system-configuration" file which assumed a printer
driver that was not available.
To prevent the error:
a) Copy the "system-configuration" file from your normal boot disk
to the bBaseIII self-booting disk, or,
b) Examine the "system-configuration" file on the bBaseIII disk to
determine what driver it is looking for, and ensure that driver
is located in your "devs/printers" directory.
14. IF YOU HAVE A PROBLEM!
If you find that either the Demo or Registered versions of bBase do not
perform according to the information found in this documentation, please
let me know. This is your program - you paid for it, and it should work
for you.
Descriptions of problems are difficult, at best. To assure a
satisfactory solution to your problem, please do the following:
1. Re-read this documentation. The answer could be right here.
If not ...
2. Copy your version of bBase onto a disk, along with a copy of one of
the databases that you are having trouble with, and mail it to me,
along with a detailed description of the problem, and the steps you
must take to make the problem recur. This will accomplish two
things. First, it will confirm that this is your legitimate,
unaltered copy, (refering, of course, to Registered versions), and
second, with the problem right in front of me, I will almost
certainly be able to ascertain, and perhaps correct, the problem.
In any case, I will naturally return your disk, hopefully with the
problem corrected.
3. Include in your letter a brief description of your computer system,
ie. Amiga model, Workbench version, amount of memory (Chip and Fast),
accelerators (if any), etc. This information will be very useful in
trouble-shooting.
Thank you for your interest in bBaseIII. If you have any comments or
suggestions regarding this program, I would be pleased to hear from you.
All correspondance will be answered.
__ Email to: (usually reliable)
/_/ __ /_
_ /_/ /_/ /_/ _ Bob_Bromley@amusers.victoria.bc.ca
Robert Bromley
1168 Timber Lane
Victoria, B.C.
CANADA V8Y 1E4